package com.neusoft.elm.dao.impl;
 import java.sql.Connection;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
 import java.util.ArrayList;
 import java.util.List;
 import com.neusoft.elm.dao.UserDao;
 import com.neusoft.elm.po.Business;
 import com.neusoft.elm.po.User;
 import com.neusoft.elm.util.DBUtil;
 public class UserDaoImpl implements UserDao{
	 private Connection con = null;
	 private PreparedStatement pst = null;
	 private ResultSet rs = null;
	 @Override
	 public User getUserByIdByPass(String userId, String password) throws Exception {
	 User user = null;
	 String sql = "select * from user where userId=? and password=?";
	 try {
	 con = DBUtil.getConnection();
	 pst = con.prepareStatement(sql);
	 pst.setString(1, userId);
	 pst.setString(2, password);
	 rs = pst.executeQuery();
	 while(rs.next()) {
	 user = new User();
	 user.setUserId(rs.getString("userId"));
	 user.setPassword(rs.getString("password"));
	 user.setUserName(rs.getString("userName"));
	 user.setUserSex(rs.getInt("userSex"));
	 user.setUserImg(rs.getString("userImg"));
	 user.setDelTag(rs.getInt("delTag"));
	 }
	 }finally {
	 DBUtil.close(rs,pst);
	 }
	 return user;
	 }
	 @Override
	 public int getUserById(String userId) throws Exception{
	 int result = 0;
	 String sql = "select count(*) from user where userId=?";
	 try {
	 con = DBUtil.getConnection();
	 pst = con.prepareStatement(sql);
	 pst.setString(1, userId);
	 rs = pst.executeQuery();
	 if(rs.next()) {
	 result = rs.getInt(1);
	 }
	 }finally {
	 DBUtil.close(rs,pst);
	 }
	 return result;
	 }
	 @Override
	 public int saveUser(User user) throws Exception{
	 int result = 0;
	 String sql = "insert into user values(?,?,?,?,?,1)";
	 try {
	 con = DBUtil.getConnection();
	 pst = con.prepareStatement(sql);
	 pst.setString(1, user.getUserId());
	 pst.setString(2, user.getPassword());
	 pst.setString(3, user.getUserName());
	 pst.setInt(4, user.getUserSex());
	 pst.setString(5, user.getUserImg());
	 result = pst.executeUpdate();
	 }finally {
	 DBUtil.close(rs,pst);
	 }
	 return result;
	 }
	 }
